package springboot.houbank.com.mapper;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import springboot.houbank.com.annotation.TestRepository;
import springboot.houbank.com.domain.User;

import java.util.List;

/**
 * Created by zhaoqiguo on 2016/8/23.
 */
@TestRepository
public interface UserMapper {

    public List<User> queryAll();

    @Select("SELECT id,username,age FROM user WHERE id=#{id};")
    User  selectOneUser (@Param("id") Integer id);
    public int insertUser(User user);
}
